package com.wechat.scheme.repo;

import com.wechat.scheme.entity.BaiduSource;
import com.wechat.scheme.repo.base.SoftDeletableRepo;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;


public interface BaiduSourceRepo extends SoftDeletableRepo<BaiduSource, String>,JpaSpecificationExecutor<BaiduSource> {


    @Query(value = "select bs.* from baidu_source bs where bs.key_word like %?1% and bs.deleted =0 ",nativeQuery = true)
    List<BaiduSource> findByKeyWordLike(String keyWord);

}
